﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="GPPNhaThuocDataSet" targetNamespace="http://tempuri.org/GPPNhaThuocDataSet.xsd" xmlns:mstns="http://tempuri.org/GPPNhaThuocDataSet.xsd" xmlns="http://tempuri.org/GPPNhaThuocDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="GPPNhaThuocConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="GPPNhaThuocConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.GPPNhaThuoc.My.MySettings.GlobalReference.Default.GPPNhaThuocConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DMDoiTuongTableAdapter" GeneratorDataComponentClassName="DMDoiTuongTableAdapter" Name="DMDoiTuong" UserDataComponentName="DMDoiTuongTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GPPNhaThuocConnectionString (MySettings)" DbObjectName="GPPNhaThuoc.dbo.DMDoiTuong" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DMDoiTuong] WHERE (([madoituong] = @Original_madoituong) AND ((@IsNull_tendoituong = 1 AND [tendoituong] IS NULL) OR ([tendoituong] = @Original_tendoituong)) AND ((@IsNull_loaidoituong = 1 AND [loaidoituong] IS NULL) OR ([loaidoituong] = @Original_loaidoituong)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_dienthoai = 1 AND [dienthoai] IS NULL) OR ([dienthoai] = @Original_dienthoai)) AND ((@IsNull_masothue = 1 AND [masothue] IS NULL) OR ([masothue] = @Original_masothue)) AND ((@IsNull_fax = 1 AND [fax] IS NULL) OR ([fax] = @Original_fax)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_madoituong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="madoituong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tendoituong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tendoituong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tendoituong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tendoituong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaidoituong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaidoituong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_loaidoituong" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="loaidoituong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masothue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DMDoiTuong] ([madoituong], [tendoituong], [loaidoituong], [diachi], [dienthoai], [masothue], [fax], [email], [ghichu], [tinhtrang], [id]) VALUES (@madoituong, @tendoituong, @loaidoituong, @diachi, @dienthoai, @masothue, @fax, @email, @ghichu, @tinhtrang, @id);
SELECT madoituong, tendoituong, loaidoituong, diachi, dienthoai, masothue, fax, email, ghichu, tinhtrang, id FROM DMDoiTuong WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@madoituong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="madoituong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tendoituong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tendoituong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@loaidoituong" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="loaidoituong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT madoituong, tendoituong, loaidoituong, diachi, dienthoai, masothue, fax, email, ghichu, tinhtrang, id FROM dbo.DMDoiTuong</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DMDoiTuong] SET [madoituong] = @madoituong, [tendoituong] = @tendoituong, [loaidoituong] = @loaidoituong, [diachi] = @diachi, [dienthoai] = @dienthoai, [masothue] = @masothue, [fax] = @fax, [email] = @email, [ghichu] = @ghichu, [tinhtrang] = @tinhtrang, [id] = @id WHERE (([madoituong] = @Original_madoituong) AND ((@IsNull_tendoituong = 1 AND [tendoituong] IS NULL) OR ([tendoituong] = @Original_tendoituong)) AND ((@IsNull_loaidoituong = 1 AND [loaidoituong] IS NULL) OR ([loaidoituong] = @Original_loaidoituong)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_dienthoai = 1 AND [dienthoai] IS NULL) OR ([dienthoai] = @Original_dienthoai)) AND ((@IsNull_masothue = 1 AND [masothue] IS NULL) OR ([masothue] = @Original_masothue)) AND ((@IsNull_fax = 1 AND [fax] IS NULL) OR ([fax] = @Original_fax)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ([id] = @Original_id));
SELECT madoituong, tendoituong, loaidoituong, diachi, dienthoai, masothue, fax, email, ghichu, tinhtrang, id FROM DMDoiTuong WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@madoituong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="madoituong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tendoituong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tendoituong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@loaidoituong" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="loaidoituong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_madoituong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="madoituong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tendoituong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tendoituong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tendoituong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tendoituong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaidoituong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaidoituong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_loaidoituong" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="loaidoituong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masothue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="madoituong" DataSetColumn="madoituong" />
              <Mapping SourceColumn="tendoituong" DataSetColumn="tendoituong" />
              <Mapping SourceColumn="loaidoituong" DataSetColumn="loaidoituong" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="dienthoai" DataSetColumn="dienthoai" />
              <Mapping SourceColumn="masothue" DataSetColumn="masothue" />
              <Mapping SourceColumn="fax" DataSetColumn="fax" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="tinhtrang" DataSetColumn="tinhtrang" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DMHangHoaTableAdapter" GeneratorDataComponentClassName="DMHangHoaTableAdapter" Name="DMHangHoa" UserDataComponentName="DMHangHoaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GPPNhaThuocConnectionString (MySettings)" DbObjectName="GPPNhaThuoc.dbo.DMHangHoa" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DMHangHoa] WHERE (([mahanghoa] = @Original_mahanghoa) AND ((@IsNull_tenhanghoa = 1 AND [tenhanghoa] IS NULL) OR ([tenhanghoa] = @Original_tenhanghoa)) AND ((@IsNull_donvitinh = 1 AND [donvitinh] IS NULL) OR ([donvitinh] = @Original_donvitinh)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ((@IsNull_tonkhotoithieu = 1 AND [tonkhotoithieu] IS NULL) OR ([tonkhotoithieu] = @Original_tonkhotoithieu)) AND ((@IsNull_tonkhotoida = 1 AND [tonkhotoida] IS NULL) OR ([tonkhotoida] = @Original_tonkhotoida)) AND ((@IsNull_loaihanghoa = 1 AND [loaihanghoa] IS NULL) OR ([loaihanghoa] = @Original_loaihanghoa)) AND ((@IsNull_thuevat = 1 AND [thuevat] IS NULL) OR ([thuevat] = @Original_thuevat)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mahanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahanghoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenhanghoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenhanghoa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenhanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhanghoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_donvitinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="donvitinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_donvitinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvitinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tonkhotoithieu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tonkhotoithieu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tonkhotoithieu" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tonkhotoithieu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tonkhotoida" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tonkhotoida" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tonkhotoida" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tonkhotoida" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaihanghoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaihanghoa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaihanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihanghoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thuevat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thuevat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thuevat" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thuevat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DMHangHoa] ([mahanghoa], [tenhanghoa], [donvitinh], [chinhanh], [tinhtrang], [tonkhotoithieu], [tonkhotoida], [loaihanghoa], [thuevat], [id]) VALUES (@mahanghoa, @tenhanghoa, @donvitinh, @chinhanh, @tinhtrang, @tonkhotoithieu, @tonkhotoida, @loaihanghoa, @thuevat, @id);
SELECT mahanghoa, tenhanghoa, donvitinh, chinhanh, tinhtrang, tonkhotoithieu, tonkhotoida, loaihanghoa, thuevat, id FROM DMHangHoa WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mahanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahanghoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenhanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhanghoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@donvitinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvitinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tonkhotoithieu" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tonkhotoithieu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tonkhotoida" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tonkhotoida" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaihanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihanghoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thuevat" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thuevat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT mahanghoa, tenhanghoa, donvitinh, chinhanh, tinhtrang, tonkhotoithieu, tonkhotoida, loaihanghoa, thuevat, id FROM dbo.DMHangHoa</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DMHangHoa] SET [mahanghoa] = @mahanghoa, [tenhanghoa] = @tenhanghoa, [donvitinh] = @donvitinh, [chinhanh] = @chinhanh, [tinhtrang] = @tinhtrang, [tonkhotoithieu] = @tonkhotoithieu, [tonkhotoida] = @tonkhotoida, [loaihanghoa] = @loaihanghoa, [thuevat] = @thuevat, [id] = @id WHERE (([mahanghoa] = @Original_mahanghoa) AND ((@IsNull_tenhanghoa = 1 AND [tenhanghoa] IS NULL) OR ([tenhanghoa] = @Original_tenhanghoa)) AND ((@IsNull_donvitinh = 1 AND [donvitinh] IS NULL) OR ([donvitinh] = @Original_donvitinh)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ((@IsNull_tonkhotoithieu = 1 AND [tonkhotoithieu] IS NULL) OR ([tonkhotoithieu] = @Original_tonkhotoithieu)) AND ((@IsNull_tonkhotoida = 1 AND [tonkhotoida] IS NULL) OR ([tonkhotoida] = @Original_tonkhotoida)) AND ((@IsNull_loaihanghoa = 1 AND [loaihanghoa] IS NULL) OR ([loaihanghoa] = @Original_loaihanghoa)) AND ((@IsNull_thuevat = 1 AND [thuevat] IS NULL) OR ([thuevat] = @Original_thuevat)) AND ([id] = @Original_id));
SELECT mahanghoa, tenhanghoa, donvitinh, chinhanh, tinhtrang, tonkhotoithieu, tonkhotoida, loaihanghoa, thuevat, id FROM DMHangHoa WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mahanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahanghoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenhanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhanghoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@donvitinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvitinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tonkhotoithieu" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tonkhotoithieu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tonkhotoida" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tonkhotoida" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaihanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihanghoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thuevat" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thuevat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mahanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahanghoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenhanghoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenhanghoa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenhanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhanghoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_donvitinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="donvitinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_donvitinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvitinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tonkhotoithieu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tonkhotoithieu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tonkhotoithieu" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tonkhotoithieu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tonkhotoida" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tonkhotoida" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tonkhotoida" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tonkhotoida" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaihanghoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaihanghoa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaihanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihanghoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thuevat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thuevat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thuevat" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thuevat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="mahanghoa" DataSetColumn="mahanghoa" />
              <Mapping SourceColumn="tenhanghoa" DataSetColumn="tenhanghoa" />
              <Mapping SourceColumn="donvitinh" DataSetColumn="donvitinh" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="tinhtrang" DataSetColumn="tinhtrang" />
              <Mapping SourceColumn="tonkhotoithieu" DataSetColumn="tonkhotoithieu" />
              <Mapping SourceColumn="tonkhotoida" DataSetColumn="tonkhotoida" />
              <Mapping SourceColumn="loaihanghoa" DataSetColumn="loaihanghoa" />
              <Mapping SourceColumn="thuevat" DataSetColumn="thuevat" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="GPPNhaThuocDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="GPPNhaThuocDataSet" msprop:Generator_UserDSName="GPPNhaThuocDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DMDoiTuong" msprop:Generator_TableClassName="DMDoiTuongDataTable" msprop:Generator_TableVarName="tableDMDoiTuong" msprop:Generator_TablePropName="DMDoiTuong" msprop:Generator_RowDeletingName="DMDoiTuongRowDeleting" msprop:Generator_RowChangingName="DMDoiTuongRowChanging" msprop:Generator_RowEvHandlerName="DMDoiTuongRowChangeEventHandler" msprop:Generator_RowDeletedName="DMDoiTuongRowDeleted" msprop:Generator_UserTableName="DMDoiTuong" msprop:Generator_RowChangedName="DMDoiTuongRowChanged" msprop:Generator_RowEvArgName="DMDoiTuongRowChangeEvent" msprop:Generator_RowClassName="DMDoiTuongRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="madoituong" msprop:Generator_ColumnVarNameInTable="columnmadoituong" msprop:Generator_ColumnPropNameInRow="madoituong" msprop:Generator_ColumnPropNameInTable="madoituongColumn" msprop:Generator_UserColumnName="madoituong">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tendoituong" msprop:Generator_ColumnVarNameInTable="columntendoituong" msprop:Generator_ColumnPropNameInRow="tendoituong" msprop:Generator_ColumnPropNameInTable="tendoituongColumn" msprop:Generator_UserColumnName="tendoituong" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loaidoituong" msprop:Generator_ColumnVarNameInTable="columnloaidoituong" msprop:Generator_ColumnPropNameInRow="loaidoituong" msprop:Generator_ColumnPropNameInTable="loaidoituongColumn" msprop:Generator_UserColumnName="loaidoituong" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachi" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dienthoai" msprop:Generator_ColumnVarNameInTable="columndienthoai" msprop:Generator_ColumnPropNameInRow="dienthoai" msprop:Generator_ColumnPropNameInTable="dienthoaiColumn" msprop:Generator_UserColumnName="dienthoai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="masothue" msprop:Generator_ColumnVarNameInTable="columnmasothue" msprop:Generator_ColumnPropNameInRow="masothue" msprop:Generator_ColumnPropNameInTable="masothueColumn" msprop:Generator_UserColumnName="masothue" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fax" msprop:Generator_ColumnVarNameInTable="columnfax" msprop:Generator_ColumnPropNameInRow="fax" msprop:Generator_ColumnPropNameInTable="faxColumn" msprop:Generator_UserColumnName="fax" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tinhtrang" msprop:Generator_ColumnVarNameInTable="columntinhtrang" msprop:Generator_ColumnPropNameInRow="tinhtrang" msprop:Generator_ColumnPropNameInTable="tinhtrangColumn" msprop:Generator_UserColumnName="tinhtrang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DMHangHoa" msprop:Generator_TableClassName="DMHangHoaDataTable" msprop:Generator_TableVarName="tableDMHangHoa" msprop:Generator_TablePropName="DMHangHoa" msprop:Generator_RowDeletingName="DMHangHoaRowDeleting" msprop:Generator_RowChangingName="DMHangHoaRowChanging" msprop:Generator_RowEvHandlerName="DMHangHoaRowChangeEventHandler" msprop:Generator_RowDeletedName="DMHangHoaRowDeleted" msprop:Generator_UserTableName="DMHangHoa" msprop:Generator_RowChangedName="DMHangHoaRowChanged" msprop:Generator_RowEvArgName="DMHangHoaRowChangeEvent" msprop:Generator_RowClassName="DMHangHoaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="mahanghoa" msprop:Generator_ColumnVarNameInTable="columnmahanghoa" msprop:Generator_ColumnPropNameInRow="mahanghoa" msprop:Generator_ColumnPropNameInTable="mahanghoaColumn" msprop:Generator_UserColumnName="mahanghoa">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenhanghoa" msprop:Generator_ColumnVarNameInTable="columntenhanghoa" msprop:Generator_ColumnPropNameInRow="tenhanghoa" msprop:Generator_ColumnPropNameInTable="tenhanghoaColumn" msprop:Generator_UserColumnName="tenhanghoa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="donvitinh" msprop:Generator_ColumnVarNameInTable="columndonvitinh" msprop:Generator_ColumnPropNameInRow="donvitinh" msprop:Generator_ColumnPropNameInTable="donvitinhColumn" msprop:Generator_UserColumnName="donvitinh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tinhtrang" msprop:Generator_ColumnVarNameInTable="columntinhtrang" msprop:Generator_ColumnPropNameInRow="tinhtrang" msprop:Generator_ColumnPropNameInTable="tinhtrangColumn" msprop:Generator_UserColumnName="tinhtrang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tonkhotoithieu" msprop:Generator_ColumnVarNameInTable="columntonkhotoithieu" msprop:Generator_ColumnPropNameInRow="tonkhotoithieu" msprop:Generator_ColumnPropNameInTable="tonkhotoithieuColumn" msprop:Generator_UserColumnName="tonkhotoithieu" type="xs:decimal" minOccurs="0" />
              <xs:element name="tonkhotoida" msprop:Generator_ColumnVarNameInTable="columntonkhotoida" msprop:Generator_ColumnPropNameInRow="tonkhotoida" msprop:Generator_ColumnPropNameInTable="tonkhotoidaColumn" msprop:Generator_UserColumnName="tonkhotoida" type="xs:decimal" minOccurs="0" />
              <xs:element name="loaihanghoa" msprop:Generator_ColumnVarNameInTable="columnloaihanghoa" msprop:Generator_ColumnPropNameInRow="loaihanghoa" msprop:Generator_ColumnPropNameInTable="loaihanghoaColumn" msprop:Generator_UserColumnName="loaihanghoa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="thuevat" msprop:Generator_ColumnVarNameInTable="columnthuevat" msprop:Generator_ColumnPropNameInRow="thuevat" msprop:Generator_ColumnPropNameInTable="thuevatColumn" msprop:Generator_UserColumnName="thuevat" type="xs:decimal" minOccurs="0" />
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DMDoiTuong" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="DMHangHoa_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DMHangHoa" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
</xs:schema>